Spring 2022 Course Syllabus Course: POFI-2350- Section: 01 Databases

Instructor Information
Instructor	Adriane Champagne
E-mail	champagneam@lamarpa.edu
Phone	(409) 984-6416
Office	Location: Madison Monroe Education - Room: 207 Hours: Monday & Wednesday 11:00 a.m.-12:00 p.m. Monday 1:15-1:45 p.m. Tuesday & Thurs 9:15 a.m.-12:30 p.m. Friday 10:50-11:50 a.m. other times by scheduled appointment.
COVID 19 Information	The Lamar State College Port Arthur (LSCPA) Student Code of Conduct COVID 19 Policy requires students who have been exposed to COVID 19 or diagnosed with COVID 19 to report their condition on the COVID 19 Notification Form (available via a link on the Student Code of Conduct COVID19 webpage). This information will be provided to the Dean of Student Services. In addition, this policy requires all students to wear face coverings in compliance with the criteria included in the policy. For more information please refer to the COVID 19 link on the LSCPA website.
Course Information
Description	In-depth instruction of database theory and the practical applications of a database. This course is designed to be repeated multiple times to improve student proficiency.
Prerequisites	None.
Learning Outcomes	1. Identifies all main ideas, supporting details, and vocabulary in reading material; demonstrates a full understanding of the reading. (PSLO ALPHA); measured by quiz. 2. Structure a database. (PSLO 3); measured by end of chapter Assessment assignment. 3. Create and format tables, forms (PSLO3), and reports.(PSLO 4); measured by end of chapter Assessment assignment. 4. Create and modify queries. (PSLO 3); measured by end of chapter Assessment assignment. 5. Manipulate data. (PSLO 3); measured by end of chapter Assessment assignment.
Core Objectives
Program Student Learning Outcomes	Demonstrates professionalism in the administrative workplace environment. Uses appropriate business administration skills. Uses appropriate office software applications. Creates effective business documents by applying ethical communication practices. Evaluates business documents.
Textbooks	Textbook Purchasing Statement: A student attending Lamar State College Port Arthur is not under any obligation to purchase a textbook from the college-affiliated bookstore. The same textbook may also be available from an independent retailer, including an online retailer. New Perspectives Microsoft Office 365 & Access 2019 Comprehensive    Mark Shellman, Sasha Vodnik    ISBN-10: 035702575X | ISBN-13: 9780357025758    Cengage Required Printed book is best********* 16GB Flash Drive (Required)
Lecture Topics Outline	Week 01/18: Syllabus review, pre-test, Blackboard and Self Service Banner Week 01/25: Creating a Database; Module 1 of Access 2019 Week 02/01: Building a Database and Defining Table Relationships; Module 2 Week 02/08: Maintaining and Querying a Database; Module 3 Week 02/15: Problem review and Exam 1 Module 1-3 Week 02/22: Creating Forms and Reports; Module 4 Week 03/01: Creating Advanced Queries and Enhancing Table Design Module 5 Week 03/08: Look up fields and Input mask Module 5 ~ Spring Break 03/14/2022-03/18/2022 ~ Week 03/22: Using form tools and creating custom forms Module 6 Week 03/29: Custom Form View Module 6 Week 04/15: Problem review and Exam 2 Module 4-6 Week 04/12: Creating Custom Reports Module 7 Week 04/19: Sharing, Integrating, and Analyzing Data; Module 8 Week 04/26/2021: Exporting Data to XML and HTML; Module 8 Week 05/03: Review & Final Exam Schedule subject to change
Major Assignments Schedule	Week 01/18: Online learning Survey Week 01/25: Tracking Patient, Visit, and Billing Data Module 1 Week 02/01: Creating the Billing and Patient Tables Module 2 and Quiz Module 1 &2 Week 02/08: Updating and retrieving information about patients, visits and Invoices; and quiz Module 3 Week 02/15: Problem review and Exam 1 Module 1-3 Week 02/22: Using forms and reports to display patient and visit data and quiz Module 4 Week 03/01: Making clinic database easier to use and Module 5 Week 03/08: Making clinic database easier to use and quiz Module 5 continued. ~ Spring Break 03/14/2022-03/18/2022 ~ Week 03/22: Creating Forms for Lakewood Community Health Services Week 03/29: Creating Forms for Lakewood Community Health Services and quiz Module 6 Week 04/15: Problem review and Exam 2 Module 4-6 Week 04/12: Creating Custom Reports for Lakewood Community Health Services Module 7 Week 04/19: Sharing, Integrating, and Analyzing Data clinic database; Module 8 Week 04/26: Exporting Data to XML and HTML clinic database; Module 8 Week 05/03: Review & Final Exam Schedule subject to change
Final Exam Date	May 9, 2022 - 9:01 AM   Through  May 9, 2022 - 9:50 PM
Grading Scale	90 - 100=A    80 - 89=B    70 - 79=C     60 - 69=D    Below 59 = F
Determination of Final Grade	Assignments and Quizzes - 60%, Exams - 40%
Course Policies
Instructor Policies	We will respect others personal space. Please maintain a six-foot distance whenever possible. Mask are encouraged. Announcements I will post announcements weekly, usually early in the week. These announcements indicate upcoming due dates and notes important to your success in this course. You should READ these Announcements every week. I also recommend using the BlackBoard app on your phone, with notifications, so that you immediately receive notices of new announcements for this class. Use your LSCPA email to communicate with me or call me at my office number 409-984-6416. Assignments: No emailed work is accepted. You must submit all of your assignments in Blackboard. Homework and/or quizzes will be given each week. The assignments will open by Tuesday and will be due by the following Monday night. This is subject to change. LATE WORK is not accepted. Due dates are given and enough time is given to complete all work. NO EXCEPTIONS. Students are responsible for completing all assigned homework, including reading assignments, by the required due dates and be prepared for each class meeting. Students are responsible for completing all assigned reading and video viewings. A failure to follow oral and/or written instructions could result in a 0 being given for the assignment. There may be virtual meetings. These meetings are not mandatory. I am using these meetings as an opportunity for you to ask questions about the reading material and/or any assignments given. Day of week and times will be announced once class begins. Grades: All grades will be posted you Blackboard under MyGrades. I will not discuss your grades over the phone or by e-mail. If you want to discuss your grades, you must come to my office in person or schedule a virtual meeting on TEAMS. Exams: Exams will be provided within a BlackBoard examination window. The exams will be timed and limited to 60 minutes maximum. Make-up exams will NOT be given. If you miss an exam, your lowest exam grade will count twice. If you miss more than one exam, those exams will be given a grade of zero. There will be a final exam. All students must take the exam on the scheduled date, and time, and failure to do so will result in a 0 on the final exam. Your exam will be graded immediately by Blackboard. Feedback on specific exam questions will be given 24 hours after the exam is due. You must work alone while taking the exam. Cheating on exams is not acceptable and will be subject to violations of the Academic Dishonesty policy which could include failing the course. Textbooks/supplies: Every student MUST have their own copy of the required textbooks by the end of the first week of class. The student will still be responsible for any assignments given. You will also need supplies to take notes. Academic Dishonesty: Copying, stealing, and/or submitting someone else s work is considered a violation of the Academic Dishonesty policy. Academic Dishonesty of any kind will not be tolerated. A student violating this policy will receive a zero on any assignment (first offense); a second incidence of academic dishonesty will result in failure of the class and meeting with program coordinator and/or department chair. Software Requirements: If you are in a course that is using a specific software, you MUST have the software available to you either on your home computer or you must use the open lab provided in the Gates Library. Reliable Internet access is required for all courses. Computer failure and lack of internet access are not acceptable excuses for missed assignments, projects, quizzes, or exams. There is access available on campus in the testing center and the Gates Memorial Library. DO NOT wait until the last minute to complete class work or exams. Do not complete assignments, quizzes, or exams on a phone or Chrome book as they will not submit properly. E-Mail/Voice Mail Etiquette: Students must use appropriate e-mail etiquette when corresponding with instructor; for example, complete sentences and a full subject line with your name and course name. Voice mail messages should be clearly spoken identifying students name, course, and a return phone number. Classroom Etiquette: The following behaviors will result in the student being asked during class time to cease the action and/or leave the classroom: using cell phones, talking, or keying while the instructor is giving instructions or during class discussions; surfing the Internet during lecture; and/or displaying a rude or negative behavior toward the instructor or other students. No cell phones should be heard during class. No blue tooth technology or recording of lectures in any format (unless approved by the instructor). No charging of cell phones or plugging in of other devices in the classroom.
Attendance Policy	Poor attendance is a leading reason for termination from a job in all areas of employment. With this factor in mind, the instructor monitors student attendance daily. In addition, attendance on a regular basis is necessary for proper skill development. ~ To be successful in this course, the student MUST purchase the assigned textbook and log into BlackBoard at least 2-3 times weekly. Regular, reliable access to BlackBoard via Internet is required for this course. Attendance is monitored via Blackboard reports of logins and interaction with face to face course. ~ Students are responsible for completing all assigned homework and for being prepared for each class face to face or online meeting. This applies even if you were absent for the previous class meeting.
Academic Honesty	Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSC-PA policies (Section IX, subsection A, in the Faculty Handbook) for consequences of academic dishonesty.
Facility Policies	No food or tobacco products are allowed in the classroom. Only students enrolled in the course are allowed in the classroom, except by special instructor permission. Use of electronic devices is prohibited.
Important Information
ADA Considerations	The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the the Office for Disability Services Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241.
MyLSCPA	Be sure to check your campus E-mail and Course Homepage using MyLSCPA campus web portal (My.LamarPA.edu). When you've logged in, click the email icon in the upper right-hand corner to check email, or click on the "My Courses" tab to get to your Course Homepage. Click the link to your course and review the information presented. It is important that you check your email and Course Homepage regularly. You can also access your grades, transcripts, and determine who your academic advisor is by using MyLSCPA.
Other
HB 2504	This syllabus is part of LSC-PA's efforts to comply with Texas House Bill 2504.
Department	Business and Industrial Technology Chair: Sheila Guillot E-mail: guillsr@lamarpa.edu Phone: (409) 984-6381 If you have a grievance, complaint, or concern about this course that has not been resolved through discussion with the Instructor, please consult the Department Chair.